
[dbo].[asi_CreateGLTransLine]
CREATE PROCEDURE [dbo].[asi_CreateGLTransLine]
@acctKey uniqueidentifier,
@amount decimal(18,4),
@invoiceKey uniqueidentifier,
@paymentKey uniqueidentifier,
@invoiceLineKey uniqueidentifier,
@description varchar(50),
@prodKey uniqueidentifier,
@finEntityKey uniqueidentifier,
@transDate datetime,
@deferralTermsKey uniqueidentifier,
@deferredIncAcctKey uniqueidentifier,
@glEntryType nvarchar(50),
@journalType int
AS
BEGIN
INSERT #tmpTransLine(AccountKey, Amount, InvoiceKey, PaymentKey, Description, ProductKey, FinEntityKey,
TransDate, DeferralTermsKey, DeferredIncomeGLAccountKey, InvoiceLineKey, GLEntryType, JournalEntryTypeCode)
VALUES (@acctKey, @amount, @invoiceKey, @paymentKey, @description , @prodKey, @finEntityKey,
@transDate, @deferralTermsKey, @deferredIncAcctKey, @invoiceLineKey, @glEntryType, @journalType)
END
GO